<?php

include "scripts/connectDB.php";

$res = mysql_query("SELECT * FROM users ORDER BY username ASC")
or die("Invalid query: " . mysql_query());
echo '<select name="user_id">';
echo '<option value="user_id">Hvem er du?</option>';

while ($row = mysql_fetch_assoc($res)) {
  $user_id = $row['user_id'];
  $username = $row['username'];
 
  echo "<option value='$user_id'>$username</option>";
  
}
echo "</select>";
?>

